Aggregates limits and constraints
This section outlines the rules that define what is and isn't possible with an aggregate and gives a basic guide to the memory that is required when calculating an aggregate.
Time to create Aggregate
The time to calculate an aggregate depends on whether Multi-pass aggregates need to be used and the number of passes that need to be made. It is also dependent on the number of records in the primary and foreign tables and the size of the function column.
When performing multi-pass aggregates, the data is first halved, then quartered, then split into 8… etc., until the calculation is able to run.
Storage Requirements
The amount of data required to store an aggregate is dependent on the data type of the aggregate.
Resolution Requirements
The function column of an aggregate must come from the
MANY side of a [ONE to MANY] link or from either side of a ONE to ONE link. It is not possible to aggregate a column from the ONE side of a [ONE to MANY] link.
